Procedure documentationImporting Bank Accounts

Prerequisites

  • You use Microsoft Office 2010 or higher that contains Microsoft Excel.

  • You have enabled the Developer tab in Microsoft Excel.

    To do so, in the Microsoft Excel, go to Start of the navigation path File Next navigation step Options Next navigation step Customize Ribbon End of the navigation path, and then add the Developer tab.

  • In the SAP GUI application, you have properly configured the number ranges for bank account technical IDs as follows:

    1. Define number ranges for bank account technical IDs in the Customizing activity Define Number Ranges for Bank Account Technical IDs, under Start of the navigation path Financial Supply Chain Management Next navigation step Cash and Liquidity Management Next navigation step Bank Account Management Next navigation step Basic Settings End of the navigation path.

    2. Specify a number range for bank account technical IDs in the Customizing activity Define Settings for Bank Account Master Data, under Start of the navigation path Financial Supply Chain Management Next navigation step Cash and Liquidity Management Next navigation step Bank Account Management Next navigation step Basic Settings End of the navigation path, on the Bank Account Master Data Setting tab.

  • You can defined banks for the bank accounts to be imported in the target system.

Procedure

  1. From the Manage Bank Accounts app, choose Start of the navigation path Tool Next navigation step Import and Export Bank Accounts End of the navigation path.

  2. To prepare bank account data to be migrated, download the template by choosing Download XML Spreadsheet Template.

  3. Save and open the file XML_SpreadSheet_Template.xml.

  4. In the XML file, fill in information that is essential to your business operations either by manual entering data or by copying and pasting data to the corresponding sheets.

  5. On the Developer tab, choose Export to export the data as an XML file.

  6. To import the bank accounts, specify the import path of the XML source data file and then choose Import to upload the file.

    You can choose either of the following two modes for the import:

    • Overwrite mode: By selecting the Overwrite option, if you leave a field blank in the source file, the respective field in the bank account master data will be erased after the import.

    • Update mode: By deselecting the Overwrite option, empty fields in the source file will be ignored during the import. Only fields with values will be updated after the import.

    Note Note

    • Before you export data Microsoft Excel, check the data and make sure the following:

      • All the bank account entries you want to import are inside the blue frame.

        The application does not import data outside of the frame.

      • There are no empty rows between bank account entries.

        The application treats empty rows as incorrect entries.

    • We recommend that you first choose Import with Test Run to simulate the import and check potential issues.

    End of the note.

  7. If you encounter errors, select an entry and then choose the Details button to check the details.

More Information

Exporting Bank Accounts